<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ include file="datalink.jsp" %>
    <html>
        <head>
        <meta http-equiv="Content-Type" content="text/html; charset=ISO-utf-8">
        <title>check</title>
        <style>
            #a {
            width:50%;
            height:100%;
            margin-left:25%;
            border: 1px dashed ;
            background-color:rgba(46, 184, 194, 0.397);
            text-align:center;
            }
            body{
                text-align:center;
                background-color:lightblue;
            }
            #ku {
            width:19%;
            height:50px;
            border: 1px dashed ;
            background-color:rgba(46, 184, 194, 0.397);
            text-align:center;
            float: left;
            }
        </style>
        </head>
        <body>
        <div id="a">
        <form method="post" action="">
        <% 
            Statement st = null;
           st = conn.createStatement();
           String classroom=request.getParameter("classroom");
           String exej="SELECT * FROM class where classroom ='"+classroom+"';";
           ResultSet rs = null;  

           rs = st.executeQuery(exej);
           %><div>
            <div id="ku" style="color: crimson;"><b><%out.print("课序号");%></b></div>
            <div id="ku" style="color: crimson;"><b><%out.print("课程名");%></b></div>
            <div id="ku" style="color: crimson;"><b><%out.print("教室");%></b></div>
            <div id="ku" style="color: crimson;"><b><%out.print("周几");%></b></div>
            <div id="ku" style="color: crimson;"><b><%out.print("节次");%></b></div>
        </div><%
           while (rs.next()){
            %><div>
                <div id="ku"><%out.print(rs.getString(1));%> </div>
                <div id="ku"><%out.print(rs.getString(2));%> </div>
                <div id="ku"><%out.print(rs.getString(3));%> </div>
                <div id="ku"><%out.print(rs.getString(6));%> </div>
                <div id="ku"><%out.print(rs.getString(7));%> </div>
            </div><%
           }

        %>
        </form>
        <button onclick="window.location.href='./srjs.jsp'" type="button" id="add" >返回</button>
        </div>
        </body>
        </html>